Is the link down? I went to change the setting from all 'boxes to
just my backyard. Now all I get is this error message:
"Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 12759, '2006-07-26
18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
B.maintainerID, M.Name, M.bStatusOK, S.stFullName, B.city, B.county,
B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir, B.link,
S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type, C.ctyRegion,
B.expireDate FROM Boxes AS B JOIN States AS S JOIN County AS C JOIN
Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
F.MemberID="12759") WHERE S.stateID = B.state AND ( B.county =
C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID = M.MemberID AND
C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC LIMIT
25', '0.2697' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC
LIMIT 25', '0.2)
Session halted."
Thanx,
Connfederate
LbNA Whats New link?
4 messages in this thread |
Started on 2006-07-26
LbNA Whats New link?
From: connfederate (connfederate@yahoo.com) |
Date: 2006-07-26 23:29:15 UTC
Re: [LbNA] LbNA Whats New link?
From: Suzanne Coe (wilmcoe@yahoo.com) |
Date: 2006-07-27 03:23:25 UTC-07:00
Maybe it's clues to a letterbox in your backyard =)
connfederate wrote: Is the link down? I went to change the setting from all 'boxes to
just my backyard. Now all I get is this error message:
"Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 12759, '2006-07-26
18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
B.maintainerID, M.Name, M.bStatusOK, S.stFullName, B.city, B.county,
B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir, B.link,
S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type, C.ctyRegion,
B.expireDate FROM Boxes AS B JOIN States AS S JOIN County AS C JOIN
Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
F.MemberID="12759") WHERE S.stateID = B.state AND ( B.county =
C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID = M.MemberID AND
C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC LIMIT
25', '0.2697' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC
LIMIT 25', '0.2)
Session halted."
Thanx,
Connfederate
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
connfederate
just my backyard. Now all I get is this error message:
"Database error: Invalid SQL: INSERT INTO `SearchLog` ( `MemberID` ,
`datim` , `query`, `queryTime` ) VALUES ( 12759, '2006-07-26
18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
B.maintainerID, M.Name, M.bStatusOK, S.stFullName, B.city, B.county,
B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir, B.link,
S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type, C.ctyRegion,
B.expireDate FROM Boxes AS B JOIN States AS S JOIN County AS C JOIN
Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
F.MemberID="12759") WHERE S.stateID = B.state AND ( B.county =
C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID = M.MemberID AND
C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC LIMIT
25', '0.2697' )
MySQL Error: 1064 (You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Hartford CT' AND B.ID >20000 ORDER BY B.ID DESC
LIMIT 25', '0.2)
Session halted."
Thanx,
Connfederate
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Re: [LbNA] LbNA Whats New link?
From: (john@johnsblog.com) |
Date: 2006-07-27 08:16:21 UTC-04:00
Looks OK to me now. You may have caught the page while I
was making a change. I've been working to make the queries
faster and sometimes create problems as I'm working.
Choi
On Wed, 26 Jul 2006 23:29:15 -0000
"connfederate" wrote:
> Is the link down? I went to change the setting from all
>'boxes to
> just my backyard. Now all I get is this error message:
>
> "Database error: Invalid SQL: INSERT INTO `SearchLog` (
>`MemberID` ,
> `datim` , `query`, `queryTime` ) VALUES ( 12759,
>'2006-07-26
> 18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
> B.maintainerID, M.Name, M.bStatusOK, S.stFullName,
>B.city, B.county,
> B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir,
>B.link,
> S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type,
>C.ctyRegion,
> B.expireDate FROM Boxes AS B JOIN States AS S JOIN
>County AS C JOIN
> Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
>F.MemberID="12759") WHERE S.stateID = B.state AND (
>B.county =
> C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID =
>M.MemberID AND
> C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY
>B.ID DESC LIMIT
> 25', '0.2697' )
> MySQL Error: 1064 (You have an error in your SQL syntax.
>Check the
> manual that corresponds to your MySQL server version for
>the right
> syntax to use near 'Hartford CT' AND B.ID >20000 ORDER
>BY B.ID DESC
> LIMIT 25', '0.2)
> Session halted."
>
> Thanx,
> Connfederate
>
>
>
>
was making a change. I've been working to make the queries
faster and sometimes create problems as I'm working.
Choi
On Wed, 26 Jul 2006 23:29:15 -0000
"connfederate"
> Is the link down? I went to change the setting from all
>'boxes to
> just my backyard. Now all I get is this error message:
>
> "Database error: Invalid SQL: INSERT INTO `SearchLog` (
>`MemberID` ,
> `datim` , `query`, `queryTime` ) VALUES ( 12759,
>'2006-07-26
> 18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
> B.maintainerID, M.Name, M.bStatusOK, S.stFullName,
>B.city, B.county,
> B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir,
>B.link,
> S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type,
>C.ctyRegion,
> B.expireDate FROM Boxes AS B JOIN States AS S JOIN
>County AS C JOIN
> Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
>F.MemberID="12759") WHERE S.stateID = B.state AND (
>B.county =
> C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID =
>M.MemberID AND
> C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY
>B.ID DESC LIMIT
> 25', '0.2697' )
> MySQL Error: 1064 (You have an error in your SQL syntax.
>Check the
> manual that corresponds to your MySQL server version for
>the right
> syntax to use near 'Hartford CT' AND B.ID >20000 ORDER
>BY B.ID DESC
> LIMIT 25', '0.2)
> Session halted."
>
> Thanx,
> Connfederate
>
>
>
>
Re: [LbNA] LbNA Whats New link?
From: connfederate (connfederate@yahoo.com) |
Date: 2006-07-28 01:56:20 UTC
Hi Choi,
As of this posting, the link still displays the quoted error
message. I even tried the computer at work this afternoon. The link
worked fine when I first clicked it (All Areas) but I got the same
error message when I attempted to redefine the search to Hartford
County (Conn).
Thanks for your reply and your efforts at maintaining the LbNA site!
Connfederate
--- In letterbox-usa@yahoogroups.com, wrote:
>
> Looks OK to me now. You may have caught the page while I
> was making a change. I've been working to make the queries
> faster and sometimes create problems as I'm working.
>
> Choi
>
> On Wed, 26 Jul 2006 23:29:15 -0000
> "connfederate" wrote:
> > Is the link down? I went to change the setting from all
> >'boxes to
> > just my backyard. Now all I get is this error message:
> >
> > "Database error: Invalid SQL: INSERT INTO `SearchLog` (
> >`MemberID` ,
> > `datim` , `query`, `queryTime` ) VALUES ( 12759,
> >'2006-07-26
> > 18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
> > B.maintainerID, M.Name, M.bStatusOK, S.stFullName,
> >B.city, B.county,
> > B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir,
> >B.link,
> > S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type,
> >C.ctyRegion,
> > B.expireDate FROM Boxes AS B JOIN States AS S JOIN
> >County AS C JOIN
> > Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
> >F.MemberID="12759") WHERE S.stateID = B.state AND (
> >B.county =
> > C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID =
> >M.MemberID AND
> > C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY
> >B.ID DESC LIMIT
> > 25', '0.2697' )
> > MySQL Error: 1064 (You have an error in your SQL syntax.
> >Check the
> > manual that corresponds to your MySQL server version for
> >the right
> > syntax to use near 'Hartford CT' AND B.ID >20000 ORDER
> >BY B.ID DESC
> > LIMIT 25', '0.2)
> > Session halted."
> >
> > Thanx,
> > Connfederate
> >
> >
> >
> >
>
As of this posting, the link still displays the quoted error
message. I even tried the computer at work this afternoon. The link
worked fine when I first clicked it (All Areas) but I got the same
error message when I attempted to redefine the search to Hartford
County (Conn).
Thanks for your reply and your efforts at maintaining the LbNA site!
Connfederate
--- In letterbox-usa@yahoogroups.com,
>
> Looks OK to me now. You may have caught the page while I
> was making a change. I've been working to make the queries
> faster and sometimes create problems as I'm working.
>
> Choi
>
> On Wed, 26 Jul 2006 23:29:15 -0000
> "connfederate"
> > Is the link down? I went to change the setting from all
> >'boxes to
> > just my backyard. Now all I get is this error message:
> >
> > "Database error: Invalid SQL: INSERT INTO `SearchLog` (
> >`MemberID` ,
> > `datim` , `query`, `queryTime` ) VALUES ( 12759,
> >'2006-07-26
> > 18:24:39', 'SELECT B.placeDate, B.lboxName, B.ownerID,
> > B.maintainerID, M.Name, M.bStatusOK, S.stFullName,
> >B.city, B.county,
> > B.clueDiff, B.terrainDiff, M.MemberID, B.ID, B.redir,
> >B.link,
> > S.stAbbr, B.numBoxes, B.active, F.dateFound, F.type,
> >C.ctyRegion,
> > B.expireDate FROM Boxes AS B JOIN States AS S JOIN
> >County AS C JOIN
> > Members AS M LEFT JOIN Found AS F ON (B.ID=F.BoxID AND
> >F.MemberID="12759") WHERE S.stateID = B.state AND (
> >B.county =
> > C.CNTYNAME AND B.state = C.stateID ) AND B.ownerID =
> >M.MemberID AND
> > C.ctyRegion = 'Hartford CT' AND B.ID >20000 ORDER BY
> >B.ID DESC LIMIT
> > 25', '0.2697' )
> > MySQL Error: 1064 (You have an error in your SQL syntax.
> >Check the
> > manual that corresponds to your MySQL server version for
> >the right
> > syntax to use near 'Hartford CT' AND B.ID >20000 ORDER
> >BY B.ID DESC
> > LIMIT 25', '0.2)
> > Session halted."
> >
> > Thanx,
> > Connfederate
> >
> >
> >
> >
>